package com.sql.test.service;

import android.content.Context;

import java.util.ArrayList;

/**
 * Created by Lenovo on 2018/5/2.
 */

public interface DatabaseService {
    public   void loadLocalDB(Context context);
    public  void  connectlocalDB(Context context, int openmode);
    public String getGeometryColumn();
    public  int getRecordsNumber(Context context,String tableName);
    public ArrayList<String> selectTablesName(Context context);
    public  ArrayList<String> selectCoulmnsName(Context context,String selectedTableName);
    public  ArrayList<String> selectColumnValues(Context context,String selectedTableName,String selectedColumnName);
    public  ArrayList<String[]> selectFeatureData(Context context,String selectedTableName,String selectedColumnName,String selectedColumnValue,ArrayList<String> columns,String geometryColumn);
    public ArrayList<String> selectTrigger(Context context,String tableName);
    public boolean dropAllTrigger(Context context,String tableName);
    public  boolean insertFeatureData(Context context,String insertTableName,ArrayList<String> insertTableColumns,ArrayList<String> insertFeatureData,String geometryColumn);
    public boolean createTable(Context context,String tableName,String  geometryType,ArrayList<String[]> columnsInfo);


    }
